package com.it.Mapper;

import com.it.pojo.Flight;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDate;
import java.util.List;

@Mapper
public interface FlightMapper {
    List<Flight> FSList(String departCity, String arriveCity, Integer peoNumber, LocalDate day);

    @Select("select connectTime from airport where a_name = #{aName}")
    String getConnectionTime(String aName);

    @Select("select city from airport where a_name = #{aName}")
    String getCity(String aName);

    Flight getFlightById(String fNumber);

    List<String> getTurnCityByName(List<String> aName);
}
